<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"  isELIgnored="false"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="keywords" content="拖拽特效,表格拖拽,自由排序,表格排序,列排序,JS特效"/>
<link href="css/columnDrag.css" rel="stylesheet" type="text/css"/>
<title>成绩查询</title>
</head>
<body  class="keBody">
<h1 class="keTitle">成绩查询</h1>
<div class="kePublic">
<!--效果html开始-->
<div id="chenkbox">
<div id = "headbox">
<span style="float:left;">姓名：${tea_name}</span>
<br>
<span style="float:left;">年份：<select onchange = "alterTdata()" id = "year">
 <c:forEach items="${year}" var="year" varStatus="status">
 <option value="${year}">${year}</option>
 </c:forEach>
 </select></span>
<span>课程：
<select onchange = "alterTdata()" id = "cou"> 
<option value="0">请选择</option>
 <c:forEach items="${course}" var="cou">
 <option value="${cou.c_id}">${cou.c_name}</option>
 </c:forEach>
 </select>
 </span>
 
<span style="float:right;margin-button:2px;">
 班级
 <select onchange = "alterTdata()" id = "cla">
 <option value="0">请选择</option>
 <c:forEach items="${cla}" var="cla">
 <option value="${cla.cla_id}">${cla.cla_name}</option>
 </c:forEach>
 </select></span>
</div>
<table id="tableSort">
    <tr>
          <th onclick="sortTable('tableSort',0)" title="点击排序"> 序列 </th>
          <th onclick="sortTable('tableSort',1)" title="点击排序"> 学生姓名 </th>
          <th onclick="sortTable('tableSort',2)" title="点击排序"> 学生成绩 </th>
        </tr>
  <c:set var="index" value="0" />
          <c:forEach items="${student}" var="stu">
           <tr>
           <c:set var="index" value="${index+1}" />
          <td>${index}</td>
          <td>${stu.stu_name}</td>
          <td>${stu.grade}</td>
          </tr>
 		</c:forEach>
        
  </table>
  <div id="box"></div>
</div>
<script type="text/javascript" src="js/jquery-3.4.1.min.js"></script>
<script src="js/columnDrag.js"></script>
<!--效果html结束-->
</div>
</body>
</html>